Key organizational factors in data warehouse architecture selection

a r t i c l e i n f o Keywords: Data warehousing Data warehouse architecture Archictecture selection Independent data marts Bus architecture Enterprise data warehouse Hub and spoke Federated Even though data warehousing has been in existence for over a decade, companies are still uncertain about a critical decision — which data warehouse architecture to implement? Based on the existing literature, theory, and interviews with experts, a research model was created that identifies the various contextual factors that affect the selection decision. The results from the field survey and multinomial logistic regression suggest that various combinations of organizational factors influence data warehouse architecture selection. The strategic view of the data warehouse prior to implementation emerged as a key determinant. The research suggests an overall model for predicting the data warehouse architecture selection decision. Over the past decade, many companies have made data warehouses the foundation of their decision support infrastructures. These data repositories provide a solution to a recurring problem that has plagued companies' decision support initiatives — the lack of clean, accurate, timely, and integrated data. Whether the data is used for queries and reporting, decision support systems (DSS), executive information systems (EIS), online analytical processing (OLAP), or data mining, data warehouses provide the data that " fuels " these applications [36]. Data warehouses are also critical enablers of current strategic initiatives such as customer relationship management (CRM), business performance management (BPM), and supply chain management [18,23,35,85]. Despite the importance and growing experience with data ware-housing, there is still a considerable discussion and disagreement over which architecture to use. Bill Inmon, commonly referred to as " the father of data warehousing, " advocates what is variously called the hub and spoke architecture (i.e., a centralized data warehouse with dependent data marts), Corporate Information Factory, DW 2.0 (i.e., Inmon's current term), or enterprise data warehouse architecture [23]. Another architecture alternative is the data mart bus architecture with linked dimensional data marts (i.e., bus architecture), advocated by Ralph Kimball, the other preeminent figure in data warehousing [52]. 1 These and other architectures (e.g., independent data marts and federated) have fundamental differences and strong advocates. The selection of an appropriate architecture is an important decision. A study by the Meta Group found that architecture selection is one of the key factors influencing data warehousing success [54]. A Gartner report identified the architecture selection decision as one of the five problem …